SQL Server query plan cache β what is it and why should you care?
- π
- π 380 words
- π 2 minutes
- π¦ .NET
- π·οΈ Entity Framework, LINQ, SQL Server
- π¬ 5 responses
SQL Server like all databases goes through a number of steps when it receives a command. Besides parsing and validating the command text and parameters it looks at the database schema, statistics and indexes to come up with a plan to efficiently query or change your data.
You can view the plan SQL Server comes up with for a given query in SQL Management Studio by selecting Include Actual Execution Plan from the Query menu before running your query.